/*
MySQL Backup
Database: lzycms
Backup Time: 2019-10-09 19:12:35
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `lzycms`.`ks_account`;
DROP TABLE IF EXISTS `lzycms`.`ks_account_record`;
DROP TABLE IF EXISTS `lzycms`.`ks_action`;
DROP TABLE IF EXISTS `lzycms`.`ks_action_log`;
DROP TABLE IF EXISTS `lzycms`.`ks_alliance_binding`;
DROP TABLE IF EXISTS `lzycms`.`ks_auth_extend`;
DROP TABLE IF EXISTS `lzycms`.`ks_auth_group`;
DROP TABLE IF EXISTS `lzycms`.`ks_auth_group_access`;
DROP TABLE IF EXISTS `lzycms`.`ks_auth_rule`;
DROP TABLE IF EXISTS `lzycms`.`ks_comment`;
DROP TABLE IF EXISTS `lzycms`.`ks_comment_img`;
DROP TABLE IF EXISTS `lzycms`.`ks_config`;
DROP TABLE IF EXISTS `lzycms`.`ks_config_class`;
DROP TABLE IF EXISTS `lzycms`.`ks_coupon`;
DROP TABLE IF EXISTS `lzycms`.`ks_equipment`;
DROP TABLE IF EXISTS `lzycms`.`ks_featured_shop`;
DROP TABLE IF EXISTS `lzycms`.`ks_info_adv`;
DROP TABLE IF EXISTS `lzycms`.`ks_info_article`;
DROP TABLE IF EXISTS `lzycms`.`ks_info_article_class`;
DROP TABLE IF EXISTS `lzycms`.`ks_info_bulletin`;
DROP TABLE IF EXISTS `lzycms`.`ks_info_single`;
DROP TABLE IF EXISTS `lzycms`.`ks_member`;
DROP TABLE IF EXISTS `lzycms`.`ks_member_level`;
DROP TABLE IF EXISTS `lzycms`.`ks_menu`;
DROP TABLE IF EXISTS `lzycms`.`ks_news`;
DROP TABLE IF EXISTS `lzycms`.`ks_order_goods`;
DROP TABLE IF EXISTS `lzycms`.`ks_pay`;
DROP TABLE IF EXISTS `lzycms`.`ks_payment`;
DROP TABLE IF EXISTS `lzycms`.`ks_picture`;
DROP TABLE IF EXISTS `lzycms`.`ks_recharge`;
DROP TABLE IF EXISTS `lzycms`.`ks_region`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_bank`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_equipment`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_img`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_order`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_product`;
DROP TABLE IF EXISTS `lzycms`.`ks_shop_product_class`;
DROP TABLE IF EXISTS `lzycms`.`ks_ucenter_member`;
CREATE TABLE `ks_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL COMMENT '商家ID   关联商家表',
  `balance` int(11) DEFAULT '0' COMMENT '余额',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商家账户表';
CREATE TABLE `ks_account_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '类型  1 添加  2 扣除',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `record_ago` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '资金变动前金额',
  `record_after` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '资金变动后金额',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商家账户资金变动记录';
CREATE TABLE `ks_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '行为唯一标识',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '行为说明',
  `remark` char(140) NOT NULL DEFAULT '' COMMENT '行为描述',
  `rule` text COMMENT '行为规则',
  `log` text COMMENT '日志规则',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统行为表';
CREATE TABLE `ks_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `action_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',
  `record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `action_ip_ix` (`action_ip`),
  KEY `action_id_ix` (`action_id`),
  KEY `user_id_ix` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';
CREATE TABLE `ks_alliance_binding` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alliance_id` int(11) NOT NULL COMMENT '加盟商ID',
  `equipment_id` int(11) NOT NULL COMMENT '设备ID',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='加盟商绑定设备表';
CREATE TABLE `ks_auth_extend` (
  `group_id` mediumint(10) unsigned NOT NULL COMMENT '用户id',
  `extend_id` mediumint(8) unsigned NOT NULL COMMENT '扩展表中数据的id',
  `type` tinyint(1) unsigned NOT NULL COMMENT '扩展类型标识 1:栏目分类权限;2:模型权限',
  UNIQUE KEY `group_extend_type` (`group_id`,`extend_id`,`type`),
  KEY `uid` (`group_id`),
  KEY `group_id` (`extend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户组与分类的对应关系表';
CREATE TABLE `ks_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '组类型',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='权限表角色组';
CREATE TABLE `ks_auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='权限角色组与用户关联表';
CREATE TABLE `ks_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='权限资源表';
CREATE TABLE `ks_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) DEFAULT NULL COMMENT '商家ID',
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `content` varchar(255) NOT NULL COMMENT '评价内容',
  `score` decimal(10,1) NOT NULL DEFAULT '0.0' COMMENT '评分',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '回复状态   0 未回复  1 已回复',
  `reply_content` varchar(255) DEFAULT NULL COMMENT '回复内容',
  `reply_time` int(11) DEFAULT '0' COMMENT '回复时间',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `del_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品评论表';
CREATE TABLE `ks_comment_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL COMMENT '评论ID',
  `img` varchar(255) NOT NULL COMMENT '图片路径',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='评论图片表';
CREATE TABLE `ks_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='参数配置表';
CREATE TABLE `ks_config_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `pid` int(11) DEFAULT '0' COMMENT '父类id',
  `icon` varchar(255) DEFAULT NULL,
  `list_order` int(11) DEFAULT '0',
  `tip` text,
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='参数配置分类表';
CREATE TABLE `ks_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '优惠卷名称',
  `title` varchar(255) NOT NULL COMMENT '优惠卷副标题',
  `tou_num` int(11) NOT NULL DEFAULT '0' COMMENT '投放数量',
  `full_money` int(11) NOT NULL DEFAULT '0' COMMENT '满多少金额（只能整数）',
  `reduce_money` int(11) DEFAULT '0' COMMENT '减少金额（只能整数）',
  `get_num` int(11) NOT NULL DEFAULT '0' COMMENT '领取的数量',
  `start_time` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `describe` varchar(255) DEFAULT NULL COMMENT '优惠卷描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='优惠卷表';
CREATE TABLE `ks_equipment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '取餐机名称',
  `machine_code` varchar(255) DEFAULT NULL COMMENT '餐柜码',
  `machine_id` int(11) DEFAULT NULL COMMENT '餐柜ID',
  `province` int(11) NOT NULL COMMENT '省',
  `city` int(11) NOT NULL COMMENT '市',
  `area` int(11) NOT NULL COMMENT '地区',
  `address` varchar(255) NOT NULL COMMENT '地区',
  `lng` varchar(255) NOT NULL COMMENT '经度',
  `lat` varchar(255) NOT NULL COMMENT '纬度',
  `is_platform` int(11) NOT NULL DEFAULT '1' COMMENT '是否平台',
  `state` int(1) NOT NULL DEFAULT '1' COMMENT '状态    1开启   2停止',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='设备表';
CREATE TABLE `ks_featured_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='特色小店';
CREATE TABLE `ks_info_adv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '广告标题 ',
  `content` varchar(2048) NOT NULL DEFAULT '' COMMENT '广告说明',
  `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '1:幻灯片',
  `up_img` varchar(800) DEFAULT '1' COMMENT '上传图片路径',
  `link_id` varchar(255) DEFAULT NULL COMMENT '联接',
  `list_order` int(11) DEFAULT '0',
  `start_time` int(11) DEFAULT NULL COMMENT '开始时间',
  `end_time` int(11) DEFAULT NULL COMMENT '结束时间',
  `uid` int(11) DEFAULT '0' COMMENT '创建者',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '1显示，0禁用',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rt_uid_idx` (`create_time`),
  KEY `uid_status_idx` (`status`,`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
CREATE TABLE `ks_info_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '标题',
  `category_id` int(10) unsigned NOT NULL COMMENT '所属分类',
  `description` char(140) DEFAULT '' COMMENT '描述',
  `body` text COMMENT '内容',
  `position` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '推荐位',
  `hot` tinyint(4) DEFAULT '0',
  `link_id` varchar(500) DEFAULT '0' COMMENT '外链',
  `up_img` varchar(800) DEFAULT NULL COMMENT '封面(图)',
  `display` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '可见性',
  `deadline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '截至时间',
  `attach` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '附件数量',
  `view` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
  `comment` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  `extend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '扩展统计字段(点赞等统计字段)',
  `level` int(10) NOT NULL DEFAULT '0' COMMENT '优先级',
  `list_order` int(11) DEFAULT '0' COMMENT '排序',
  `status` int(11) DEFAULT '1',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_category_status` (`category_id`),
  KEY `idx_status_type_pid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='文档模型基础表';
CREATE TABLE `ks_info_article_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID',
  `name` varchar(100) NOT NULL COMMENT '分类名称',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `tip` varchar(800) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL COMMENT '名称',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键词',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `logo` int(11) DEFAULT NULL,
  `recommended` tinyint(4) DEFAULT '0' COMMENT '是否推荐',
  `typeid` tinyint(4) DEFAULT '1' COMMENT '1文字，2图片 3视频',
  `status` tinyint(4) DEFAULT '1' COMMENT '0关闭:1显示',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_id` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品分类表';
CREATE TABLE `ks_info_bulletin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '消息标题',
  `content` varchar(2048) NOT NULL DEFAULT '' COMMENT '消息内容',
  `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT ' 1运营通知 2财务 3活动 4其它',
  `lid` int(11) DEFAULT '0' COMMENT '发送类型(0.全部，2.前台，3，后台)',
  `send_type` tinyint(4) DEFAULT '1' COMMENT '发送类型(1.全部，2.前台，3，后台)',
  `up_img` varchar(255) DEFAULT NULL,
  `status_time` tinyint(4) DEFAULT '0' COMMENT '1开启0关闭',
  `start_time` varchar(100) DEFAULT NULL COMMENT '开始时间',
  `end_time` varchar(100) DEFAULT NULL COMMENT '结束时间',
  `list_order` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT '0' COMMENT '创建者',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0:显示 1:隐藏',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rt_uid_idx` (`create_time`),
  KEY `uid_status_idx` (`status`,`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='网站公告';
CREATE TABLE `ks_info_single` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '消息标题',
  `description` varchar(255) DEFAULT NULL,
  `content` text NOT NULL COMMENT '消息内容',
  `seo_key` varchar(255) DEFAULT NULL COMMENT '关键语',
  `seo_world` varchar(255) DEFAULT NULL,
  `seo_desc` varchar(255) DEFAULT NULL,
  `key` varchar(255) NOT NULL DEFAULT '0' COMMENT ' 1运营通知 2财务 3活动 4其它',
  `up_img` varchar(255) DEFAULT NULL,
  `list_order` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT '0' COMMENT '创建者',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0:显示 1:隐藏',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rt_uid_idx` (`create_time`),
  KEY `uid_status_idx` (`status`,`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='网站公告';
CREATE TABLE `ks_member` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵称',
  `logo` varchar(255) DEFAULT NULL,
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` varchar(200) NOT NULL DEFAULT '0000-00-00' COMMENT '生日',
  `score` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `login` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `otp_gg` varchar(255) DEFAULT NULL,
  `p1` int(11) DEFAULT '0' COMMENT '上级',
  `p2` int(11) DEFAULT NULL COMMENT '上上级(三级分销)',
  `pids` varchar(10240) DEFAULT NULL COMMENT '用户关系映射(无级限)',
  `create_time` int(11) DEFAULT NULL COMMENT '注册时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员状态',
  PRIMARY KEY (`uid`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='会员表';
CREATE TABLE `ks_member_level` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(50) DEFAULT NULL COMMENT '分层名称',
  `vip_pay_times` int(11) unsigned DEFAULT '0' COMMENT 'Vip付款次数',
  `vip_pay_amount` decimal(12,3) DEFAULT '0.000' COMMENT 'Vip付款总额',
  `pay_max_amount` decimal(12,3) DEFAULT '0.000' COMMENT '付款额度',
  `order_money` decimal(12,3) DEFAULT '0.000' COMMENT '累计消费总额',
  `score_all` int(11) DEFAULT '0' COMMENT '发放的金币总额',
  `score_consume` int(11) DEFAULT '0' COMMENT '消费的金币总额',
  `withdraw_times` int(11) unsigned DEFAULT '0' COMMENT '提款次数',
  `poundage_amount` decimal(10,2) DEFAULT '0.00' COMMENT '手续费总额',
  `withdraw_amount` decimal(12,3) DEFAULT '0.000' COMMENT '提款总额',
  `status` smallint(1) DEFAULT '1' COMMENT '0 不启用 1启用',
  `auto` tinyint(1) unsigned DEFAULT '1' COMMENT '自动分层 0不启用 1启用',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  `level_user_num` int(11) unsigned DEFAULT '0' COMMENT '层次用户总数，每N分钟更新一次VIP当前总人数(缓存几分鈡)',
  `vip_user_num` int(11) DEFAULT '0' COMMENT 'VIP当前总人数(缓存几分鈡)',
  `uid` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='会员分层';
CREATE TABLE `ks_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `pid` int(10) unsigned zerofill DEFAULT '0000000000' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `tip` varchar(255) DEFAULT '' COMMENT '提示',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='菜单表';
CREATE TABLE `ks_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `code` varchar(255) NOT NULL COMMENT '取餐码',
  `equipment_id` int(11) NOT NULL COMMENT '设备ID',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '消息状态  0 未读 1已读',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `del_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='消息表';
CREATE TABLE `ks_order_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL COMMENT '订单id',
  `goods_uuid` int(11) DEFAULT NULL COMMENT '售货机的商品ID',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品ID',
  `num` int(11) DEFAULT '0' COMMENT '购买数量',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订单商品表';
CREATE TABLE `ks_pay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_id` int(11) DEFAULT NULL COMMENT '支付ID',
  `pay_code` varchar(255) DEFAULT NULL COMMENT '支付类型码',
  `pay_name` varchar(255) DEFAULT NULL COMMENT '支付名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '支付状态  1 开启  0 关闭',
  `icon` varchar(255) DEFAULT NULL COMMENT '支付图标',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='支付表';
CREATE TABLE `ks_payment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `out_trade_no` char(32) NOT NULL COMMENT '支付号',
  `total_fee` int(11) NOT NULL COMMENT '支付金额',
  `appid` char(32) NOT NULL,
  `token` char(32) DEFAULT NULL,
  `openid` char(128) DEFAULT NULL,
  `callback` varchar(200) NOT NULL COMMENT '回调方法',
  `prepay_id` char(64) DEFAULT NULL,
  `code_url` char(64) DEFAULT NULL,
  `return_code` char(16) DEFAULT NULL,
  `return_msg` char(128) DEFAULT NULL,
  `result_code` char(16) DEFAULT NULL,
  `err_code_des` char(200) DEFAULT NULL,
  `cTime` int(10) NOT NULL,
  `param` text,
  `res_data` text,
  `is_pay` tinyint(1) DEFAULT '0',
  `after_pay_res` text,
  `order_id` int(11) DEFAULT NULL COMMENT '订单ID',
  PRIMARY KEY (`id`),
  KEY `out_trade_no` (`out_trade_no`,`appid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='支付表';
CREATE TABLE `ks_picture` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id自增',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '图片链接',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `token` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='图片资源上传数据库保留';
CREATE TABLE `ks_recharge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '充值类型  1 在线充值  2 后台充值',
  `recharge_ago` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值前金额',
  `recharge_after` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值后的金额',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='充值记录表';
CREATE TABLE `ks_region` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `region_name` varchar(100) DEFAULT NULL COMMENT '地区名称',
  `region_alias` varchar(100) DEFAULT NULL COMMENT '地区别名',
  `region_code` varchar(100) DEFAULT NULL COMMENT '地区代码',
  `region_type` int(11) DEFAULT NULL COMMENT '地区类型-dic(regionType)',
  `region_desc` varchar(1000) DEFAULT NULL COMMENT '地区描述',
  `parent_id` int(11) DEFAULT NULL COMMENT '上级ID',
  `lv` int(11) DEFAULT NULL COMMENT '层级',
  `id_path` varchar(1000) DEFAULT NULL COMMENT 'ID路径',
  `name_path` varchar(1000) DEFAULT NULL COMMENT '名称路径',
  `is_leaf` tinyint(4) DEFAULT '1' COMMENT '是否叶节点',
  `root_id` int(11) DEFAULT NULL COMMENT '根节点ID',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `is_available` tinyint(4) DEFAULT '1' COMMENT '是否可用',
  `region_full_name` varchar(1000) DEFAULT NULL COMMENT '地区全名',
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `ak_region_parentid` (`parent_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=50727 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='地区';
CREATE TABLE `ks_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT '0' COMMENT '管理员ID',
  `name` varchar(255) NOT NULL COMMENT '店铺名称',
  `province` int(11) NOT NULL COMMENT '省',
  `city` int(11) NOT NULL COMMENT '市',
  `area` int(11) NOT NULL COMMENT '地区',
  `address` varchar(255) NOT NULL,
  `mobile` varchar(20) NOT NULL COMMENT '手机号码',
  `head_img` varchar(255) DEFAULT '' COMMENT '用户头像图片路径',
  `open_time` varchar(255) DEFAULT NULL COMMENT '营业时间',
  `summary` varchar(255) DEFAULT NULL COMMENT '店铺简介',
  `index_img` varchar(255) DEFAULT NULL COMMENT '首页广告图',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商家表';
CREATE TABLE `ks_shop_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL COMMENT '商家ID',
  `bank_name` varchar(255) NOT NULL DEFAULT '0' COMMENT '开户行名称',
  `account_number` varchar(255) NOT NULL DEFAULT '0' COMMENT '开户号码',
  `realname` varchar(255) NOT NULL COMMENT '开户人',
  `mobile` varchar(20) NOT NULL COMMENT '银行预留的手机号码',
  `type` int(1) DEFAULT '1' COMMENT '银行类型  1 默认对私  2 对公账户',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商家银行卡表';
CREATE TABLE `ks_shop_equipment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `equipment_id` int(11) NOT NULL COMMENT '设备ID',
  `type` int(1) NOT NULL DEFAULT '0' COMMENT '设备类型  1 自营设备  2 商家设备',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '状态 0 可申请  1 待申请  2 未通过 3 已通过',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='商家设备表';
CREATE TABLE `ks_shop_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL COMMENT '商家ID',
  `img` varchar(255) NOT NULL COMMENT '图片路径',
  `type` int(1) DEFAULT '1' COMMENT '图片类型  1 店铺环境图片  2 店铺申请提交的资料图片',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商家图片';
CREATE TABLE `ks_shop_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID   默认是自营商城',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `number` varchar(255) NOT NULL COMMENT '订单号',
  `name` varchar(255) NOT NULL COMMENT '商品名称',
  `meal_machine_id` int(11) NOT NULL COMMENT '取餐机id',
  `cope_money` decimal(10,2) DEFAULT '0.00' COMMENT '应付金额',
  `pay_money` decimal(10,2) DEFAULT '0.00' COMMENT '实付金额',
  `code` varchar(255) DEFAULT NULL COMMENT '放餐码',
  `phone` char(15) NOT NULL COMMENT '手机号',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '状态 1未处理 2已处理（待评价）  3已完成',
  `order_status` tinyint(1) DEFAULT '0' COMMENT '订单状态 0 待支付 1 已支付 3 待取餐 4 待评价 5 已完成',
  `coupon_id` int(11) DEFAULT NULL COMMENT '优惠卷ID',
  `receipt` int(11) DEFAULT NULL COMMENT '发票ID',
  `pay_id` int(20) DEFAULT '0' COMMENT '支付ID   关联支付表',
  `order_time` int(11) DEFAULT NULL COMMENT '下单时间',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '处理时间',
  `appointment_time` int(11) DEFAULT '0' COMMENT '预约时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='订单表';
CREATE TABLE `ks_shop_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `equipment_id` int(11) DEFAULT NULL COMMENT '设备ID',
  `goods_uuid` int(11) DEFAULT NULL COMMENT '售货机的商品ID',
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `name` varchar(255) NOT NULL COMMENT '商品名称',
  `type` int(11) NOT NULL COMMENT '商品分类',
  `orig_price` decimal(10,2) NOT NULL COMMENT '商品原价',
  `dis_price` decimal(10,2) DEFAULT NULL COMMENT '商品折扣价',
  `sales_num` int(11) DEFAULT '0' COMMENT '销量',
  `staple_food` varchar(255) DEFAULT NULL COMMENT '规格-主食',
  `main_course` varchar(255) DEFAULT NULL COMMENT '规格-主菜',
  `side_dish` varchar(255) DEFAULT NULL COMMENT '规格-配菜',
  `taste` varchar(255) DEFAULT NULL COMMENT '规格-口味',
  `img` varchar(255) NOT NULL COMMENT '商品图片',
  `state` int(1) DEFAULT '1' COMMENT '状态   是否上架，默认1 上级 0 下架',
  `stock` int(11) DEFAULT '0' COMMENT '餐柜库存',
  `publish_time` int(11) DEFAULT '0' COMMENT '发布时间（上架时间）',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  `del_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='商品表';
CREATE TABLE `ks_shop_product_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID   0 是自营商城  ',
  `name` varchar(255) NOT NULL COMMENT '分类名称',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) NOT NULL COMMENT '修改时间',
  `del_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='商品分类表';
CREATE TABLE `ks_ucenter_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` char(200) NOT NULL COMMENT '用户名',
  `password` char(32) NOT NULL COMMENT '密码',
  `email` char(32) DEFAULT NULL COMMENT '用户邮箱',
  `mobile` char(15) NOT NULL DEFAULT '' COMMENT '用户手机',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `user_type` tinyint(4) DEFAULT '1' COMMENT '0:后台管理员,1微信,2,QQ,3,...',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='用户表';
BEGIN;
LOCK TABLES `lzycms`.`ks_account` WRITE;
DELETE FROM `lzycms`.`ks_account`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_account_record` WRITE;
DELETE FROM `lzycms`.`ks_account_record`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_action` WRITE;
DELETE FROM `lzycms`.`ks_action`;
INSERT INTO `lzycms`.`ks_action` (`id`,`name`,`title`,`remark`,`rule`,`log`,`type`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (1, 'user_login', '用户登录111', '积分+10，每天一次', '111', '[user|get_nickname]在[time|time_format]登录了后台', 1, 1, NULL, 1387181220, NULL),(2, 'add_article', '发布文章', '积分+5，每天上限5次', NULL, '', 2, 0, NULL, 1380173180, NULL),(3, 'review', '评论', '评论积分+1，无限制', NULL, '', 2, 1, NULL, 1383285646, NULL),(4, 'add_document', '发表文档', '积分+10，每天上限5次', NULL, '[user|get_nickname]在[time|time_format]发表了一篇文章。\r\n表[model]，记录编号[record]。', 2, 0, NULL, 1386139726, NULL),(5, 'add_document_topic', '发表讨论', '积分+5，每天上限10次', NULL, '', 2, 0, NULL, 1383285551, NULL),(6, 'update_config', '更新配置', '新增或修改或删除配置', '', '', 1, 1, NULL, 1383294988, NULL),(7, 'update_model', '更新模型', '新增或修改模型', '', '', 1, 1, NULL, 1383295057, NULL),(8, 'update_attribute', '更新属性', '新增或更新或删除属性', '', '', 1, 1, NULL, 1383295963, NULL),(9, 'update_channel', '更新导航', '新增或修改或删除导航', '', '', 1, 1, NULL, 1383296301, NULL),(10, 'update_menu', '更新菜单', '新增或修改或删除菜单', '', '', 1, 1, NULL, 1383296392, NULL),(11, 'update_category', '更新分类', '新增或修改或删除分类', '', '', 1, 1, NULL, 1383296765, NULL),(14, 'test1111444', '测试', '1231231', '3123', '3123', 2, 0, 1531985256, 1531985256, NULL),(13, 'test1111', '测试', '1231231', '3123', '3123', 2, 0, 1531984899, 1531994024, 1531994024);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_action_log` WRITE;
DELETE FROM `lzycms`.`ks_action_log`;
INSERT INTO `lzycms`.`ks_action_log` (`id`,`action_id`,`user_id`,`action_ip`,`model`,`record_id`,`remark`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (52, 1, 1, 2130706433, 'Member', 1, '超级管理员在2019-03-28 18:16登录了后台', 1, 1553768211, NULL, NULL),(53, 1, 1, 2130706433, 'Member', 1, '超级管理员在2019-03-28 18:18登录了后台', 1, 1553768318, NULL, NULL),(54, 1, 1, 2130706433, 'Member', 1, '超级管理员在2019-03-28 18:18登录了后台', 1, 1553768337, NULL, NULL),(55, 1, 1, 2130706433, 'Member', 1, '超级管理员在2019-03-28 18:19登录了后台', 1, 1553768389, NULL, NULL),(56, 1, 1, 2130706433, 'Member', 1, '超级管理员在2019-03-28 18:20登录了后台', 1, 1553768435, NULL, NULL),(57, 1, 1, 0, 'Member', 1, '超级管理员在2019-09-06 22:52登录了后台', 1, 1567781566, NULL, NULL),(58, 1, 1, 0, 'Member', 1, '超级管理员在2019-09-08 15:06登录了后台', 1, 1567926413, NULL, NULL),(59, 1, 1, 0, 'Member', 1, '在2019-10-09 14:30登录了后台', 1, 1570602652, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_alliance_binding` WRITE;
DELETE FROM `lzycms`.`ks_alliance_binding`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_auth_extend` WRITE;
DELETE FROM `lzycms`.`ks_auth_extend`;
INSERT INTO `lzycms`.`ks_auth_extend` (`group_id`,`extend_id`,`type`) VALUES (1, 1, 1),(1, 1, 2),(1, 2, 1),(1, 2, 2),(1, 3, 1),(1, 3, 2),(1, 4, 1),(1, 37, 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_auth_group` WRITE;
DELETE FROM `lzycms`.`ks_auth_group`;
INSERT INTO `lzycms`.`ks_auth_group` (`id`,`module`,`type`,`title`,`description`,`status`,`rules`) VALUES (1, 'admin', 1, '默认用户组', '', 1, '1,2,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,79,80,81,82,83,84,86,87,88,89,90,91,92,93,94,95,96,97,100,102,103,105,106'),(2, 'admin', 1, '测试组11', '测试用户', 1, '0,14,2,3,8,9,10,4,5'),(3, 'admin', 0, '12312', '1231231', 1, ''),(5, 'admin', 0, 'dsfsdfs', 'dsfsdfs', 1, ''),(7, 'admin', 0, '222', '2222', 1, '');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_auth_group_access` WRITE;
DELETE FROM `lzycms`.`ks_auth_group_access`;
INSERT INTO `lzycms`.`ks_auth_group_access` (`uid`,`group_id`) VALUES (7, 2),(8, 3);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_auth_rule` WRITE;
DELETE FROM `lzycms`.`ks_auth_rule`;
INSERT INTO `lzycms`.`ks_auth_rule` (`id`,`module`,`type`,`name`,`title`,`status`,`condition`) VALUES (1, 'Admin', 2, 'admin/console', '控制台', 1, ''),(2, 'Admin', 2, 'admin/system/*', '系统管理', 1, ''),(3, 'Admin', 1, 'admin/menu/index', '菜单管理', 1, ''),(4, 'Admin', 2, 'admin/user/*', '用户管理', 1, ''),(5, 'Admin', 1, 'admin/member/index', '用户信息', 1, ''),(6, 'admin', 1, 'admin/auth/manager/index', '权限管理', -1, ''),(7, 'admin', 1, 'admin/user/action/index', '用户行为', -1, ''),(8, 'Admin', 1, 'admin/config/group', '配置管理', 1, ''),(9, 'admin', 1, 'admin/config/class/index', '配置分类', -1, ''),(10, 'admin', 1, 'admin/database/option/export', '备份数据库', -1, ''),(11, 'admin', 1, 'admin/user/actionlog/index', '用户行为日志', -1, ''),(12, 'Admin', 2, 'admin/shop/*', '商城管理', 1, ''),(13, 'admin', 1, 'admin/shop/goods/index', '产品列表', -1, ''),(14, 'admin', 2, 'admin/index/index', '控制台', -1, ''),(15, 'Admin', 1, 'admin/database/option/index', '备份数据库', 1, ''),(16, 'Admin', 1, 'admin/database/option/import', '还原数据库', 1, ''),(17, 'Admin', 1, 'admin/shop/goods/class/index', '商品分类', 1, ''),(18, 'admin', 2, 'admin/test', 'test', -1, ''),(19, 'Admin', 1, 'admin/authmanager/index', '权限管理', 1, ''),(20, 'Admin', 1, 'admin/action/index', '用户行为', 1, ''),(21, 'Admin', 1, 'admin/config/index', '配置分类', 1, ''),(22, 'Admin', 1, 'admin/actionlog/index', '用户行为日志', 1, ''),(23, 'Admin', 1, 'admin/goods/index', '产品列表', 1, ''),(24, 'Admin', 2, 'admin/content', '内容管理', 1, ''),(25, 'Admin', 1, 'admin/adv/index', '广告管理', 1, ''),(26, 'Admin', 1, 'admin/article/index', '新闻管理', 1, ''),(27, 'Admin', 1, 'admin/articleclass/index', '新闻分类', 1, ''),(28, 'Admin', 1, 'admin/bulletin/index', '公告管理', 1, ''),(29, 'Admin', 1, 'admin/memberlevel/index', '用户层级', 1, '');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_comment` WRITE;
DELETE FROM `lzycms`.`ks_comment`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_comment_img` WRITE;
DELETE FROM `lzycms`.`ks_comment_img`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_config` WRITE;
DELETE FROM `lzycms`.`ks_config`;
INSERT INTO `lzycms`.`ks_config` (`id`,`name`,`type`,`title`,`remark`,`create_time`,`update_time`,`status`,`value`,`sort`) VALUES (1, 'WEB_SITE_TITLE', 2, '网站标题11', '网站标题前台显示标题', 1378898976, 1379235274, 1, '钉石云网络公司', 0),(2, 'WEB_SITE_DESCRIPTION', 2, '网站描述2222', '网站搜索引擎描述', 1378898976, 1531478801, 1, 'OneThink内容管理框架', 1),(3, 'WEB_SITE_KEYWORD', 2, '网站关键字', '网站搜索引擎关键字', 1378898976, 1381390100, 1, 'ThinkPHP,OneThink', 8),(4, 'WEB_SITE_CLOSE', 4, '关闭站点', '站点关闭后其他用户不能访问，管理员可以正常访问', 1378898976, 1379235296, 1, '1', 1),(9, 'CONFIG_TYPE_LIST', 3, '配置类型列表', '主要用于数据解析和页面表单的生成', 1378898976, 1379235348, 1, '0:数字\r\n1:字符\r\n2:文本\r\n3:数组\r\n4:枚举', 2),(10, 'WEB_SITE_ICP', 2, '网站备案号', '设置在网站底部显示的备案号，如“沪ICP备12007941号-2', 1378900335, 1379235859, 1, '', 9),(11, 'DOCUMENT_POSITION', 3, '文档推荐位', '文档推荐位，推荐到多个位置KEY值相加即可', 1379053380, 1379235329, 1, '1:列表推荐\r\n2:频道推荐\r\n4:首页推荐', 3),(12, 'DOCUMENT_DISPLAY', 3, '文档可见性', '文章可见性仅影响前台显示，后台不收影响', 1379056370, 1379235322, 1, '0:所有人可见\r\n1:仅注册会员可见\r\n2:仅管理员可见', 4),(13, 'COLOR_STYLE', 4, '后台色系', '后台颜色风格', 1379122533, 1379235904, 1, 'default_color', 10),(20, 'CONFIG_GROUP_LIST', 3, '配置分组11', '配置分组', 1379228036, 1384418383, 1, '1:基本\n2:内容\n3:用户\n4:系统', 4),(21, 'HOOKS_TYPE', 3, '钩子的类型', '类型 1-用于扩展显示内容，2-用于扩展业务处理', 1379313397, 1379313407, 1, '1:视图\r\n2:控制器', 6),(22, 'AUTH_CONFIG', 3, 'Auth配置', '自定义Auth.class.php类配置', 1379409310, 1379409564, 1, 'AUTH_ON:1\r\nAUTH_TYPE:2', 8),(23, 'OPEN_DRAFTBOX', 4, '是否开启草稿功能', '新增文章时的草稿功能配置', 1379484332, 1379484591, 1, '1', 1),(24, 'DRAFT_AOTOSAVE_INTERVAL', 0, '自动保存草稿时间', '自动保存草稿的时间间隔，单位：秒', 1379484574, 1386143323, 1, '60', 2),(25, 'LIST_ROWS', 0, '后台每页记录数', '后台数据每页显示记录数', 1379503896, 1380427745, 1, '10', 10),(26, 'USER_ALLOW_REGISTER', 4, '是否允许用户注册', '是否开放用户注册', 1379504487, 1379504580, 1, '1', 3),(27, 'CODEMIRROR_THEME', 4, '预览插件的CodeMirror主题', '详情见CodeMirror官网', 1379814385, 1384740813, 1, 'ambiance', 3),(28, 'DATA_BACKUP_PATH', 1, '数据库备份根路径', '路径必须以 / 结尾', 1381482411, 1381482411, 1, './Data/', 5),(29, 'DATA_BACKUP_PART_SIZE', 0, '数据库备份卷大小', '该值用于限制压缩后的分卷最大长度。单位：B；建议设置20M', 1381482488, 1381729564, 1, '20971520', 7),(30, 'DATA_BACKUP_COMPRESS', 4, '数据库备份文件是否启用压缩', '压缩备份文件需要PHP环境支持gzopen,gzwrite函数', 1381713345, 1381729544, 1, '1', 9),(31, 'DATA_BACKUP_COMPRESS_LEVEL', 4, '数据库备份文件压缩级别', '数据库备份文件的压缩级别，该配置在开启压缩时生效', 1381713408, 1381713408, 1, '9', 10),(32, 'DEVELOP_MODE', 4, '开启开发者模式', '是否开启开发者模式', 1383105995, 1383291877, 1, '1', 11),(33, 'ALLOW_VISIT', 3, '不受限控制器方法', '', 1386644047, 1386644741, 1, '0:article/draftbox\r\n1:article/mydocument\r\n2:Category/tree\r\n3:Index/verify\r\n4:file/upload\r\n5:file/download\r\n6:user/updatePassword\r\n7:user/updateNickname\r\n8:user/submitPassword\r\n9:user/submitNickname\r\n10:file/uploadpicture', 0),(34, 'DENY_VISIT', 3, '超管专限控制器方法', '仅超级管理员可访问的控制器方法', 1386644141, 1386644659, 1, '0:Addons/addhook\r\n1:Addons/edithook\r\n2:Addons/delhook\r\n3:Addons/updateHook\r\n4:Admin/getMenus\r\n5:Admin/recordList\r\n6:AuthManager/updateRules\r\n7:AuthManager/tree', 0),(35, 'REPLY_LIST_ROWS', 0, '回复列表每页条数', '', 1386645376, 1387178083, 1, '10', 0),(36, 'ADMIN_ALLOW_IP', 2, '后台允许访问IP', '多个用逗号分隔，如果不配置表示不限制IP访问', 1387165454, 1387165553, 1, '', 12),(37, 'SHOW_PAGE_TRACE', 4, '是否显示页面Trace', '是否显示页面Trace信息', 1387165685, 1387165685, 1, '0', 1),(42, 'BACKEND_SWITCH_OTP', 1, '设置Google验证', 'GOOGLE验证', 1531997663, 1532572908, 1, '0', 50),(43, 'LZY_COMPANY', 2, '公司名称', '公司名称', 1531997663, 1531997663, 1, '微云商', 0),(44, 'LZY_VERSION', 2, '版本号', '版本号', 1531997663, 1531997663, 1, '1.001', 0),(45, 'LZY_COMPANY_URL', 2, '公司联接', '公司联接', 1531997663, 1531997663, 1, 'http://www.dingshiyun.com', 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_config_class` WRITE;
DELETE FROM `lzycms`.`ks_config_class`;
INSERT INTO `lzycms`.`ks_config_class` (`id`,`name`,`pid`,`icon`,`list_order`,`tip`,`create_time`,`update_time`,`status`) VALUES (1, '系统配置', 0, 'layui-icon layui-icon-set-fill', 50, NULL, 0, 1531980842, 1),(2, '七牛配置', 1, 'layui-icon layui-icon-face-cry', 50, NULL, 0, 1540978052, 1),(3, '微信配置', 44, 'layui-icon layui-icon-add-circle', 0, NULL, 0, 1541484296, 1),(44, '微信开发', 0, 'fa fa-file-o', 50, NULL, 1541484196, 1541484267, 1),(45, '小程序配置', 44, 'fa fa-file-o', 50, NULL, 1541484314, 1541484314, 1),(46, '腾讯云设置', 1, 'layui-icon layui-icon-set-fill', 50, NULL, 1541732298, 1541732298, 1),(47, '手续费配配', 1, 'layui-icon layui-icon-set-fill', 50, NULL, 1541736047, 1541736047, 1),(48, '1231231', 0, 'fa fa-file-o', 50, '', 0, 0, 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_coupon` WRITE;
DELETE FROM `lzycms`.`ks_coupon`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_equipment` WRITE;
DELETE FROM `lzycms`.`ks_equipment`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_featured_shop` WRITE;
DELETE FROM `lzycms`.`ks_featured_shop`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_info_adv` WRITE;
DELETE FROM `lzycms`.`ks_info_adv`;
INSERT INTO `lzycms`.`ks_info_adv` (`id`,`title`,`content`,`type`,`up_img`,`link_id`,`list_order`,`start_time`,`end_time`,`uid`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (9, 'dsfsdf', '1232131', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541130862, 1542870568, 1542870568),(10, 'aaaaaaaaaaaaaaaaaa', 'aaaaaaaaaaaaaaaaaaaaa', 2, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 0, 1541130932, 1541389668, 1541389668),(11, 'dasd', '12312312231', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131019, 1542870569, 1542870569),(12, 'dasd', '', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131084, 1542870571, 1542870571),(14, '123', '12312312', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131213, 1542870580, 1542870580),(15, 'fsdf', 'safasfa', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131288, 1541139047, 1541139047),(16, 'fsdaf', 'asfda', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131368, 1541139041, 1541139041),(17, '1231', '231231', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131468, 1541138962, 1541138962),(18, 'fdsaf', 'asfdadfa', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541131561, 1541139033, 1541139033),(19, '123', '123123', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541834459, 1542870581, 1542870581),(20, '12312', '31231', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541834477, 1542870583, 1542870583),(21, 'aaaaaaaaaaa', '423424', 1, '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', NULL, 50, NULL, NULL, 1, 1, 1541834527, 1542870585, 1542870585),(22, '1231231231', '231231231', 1, '/uploads/2018-11-15-06-23-27-5bed10df9a657.png', NULL, 50, NULL, NULL, 1, 1, 1542356662, 1542870587, 1542870587),(23, '3234234', '234242342', 1, 'http://www.xmcrb.com/uploads/2018-11-29-03-19-12-5bff5ab034b82.jpg', NULL, 50, NULL, NULL, 1, 1, 1542870761, 1543461553, NULL),(24, 'sfsf', 'sdfsfsfs', 1, 'http://www.xmcrb.com/uploads/2018-11-29-03-19-21-5bff5ab9cc416.jpg', 'sdfsfsfs', 50, NULL, NULL, 1, 1, 1542870777, 1543461563, NULL),(25, 'aaa', 'aaaa', 1, 'https://www.xmcrb.com/uploads/2018-11-22-07-38-06-5bf65cde7414e.jpg', NULL, 50, NULL, NULL, 1, 1, 1542872431, 1542873319, 1542873319),(26, '123', '1231231', 1, 'https://www.xmcrb.com/uploads/2018-11-22-07-38-06-5bf65cde7414e.jpg', NULL, 50, NULL, NULL, 1, 1, 1542872644, 1542873317, 1542873317),(27, '12', '321313', 1, 'http://www.xmcrb.com/uploads/2018-11-29-03-19-35-5bff5ac7ca97a.jpg', NULL, 50, NULL, NULL, 1, 1, 1542872683, 1543461577, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_info_article` WRITE;
DELETE FROM `lzycms`.`ks_info_article`;
INSERT INTO `lzycms`.`ks_info_article` (`id`,`uid`,`title`,`category_id`,`description`,`body`,`position`,`hot`,`link_id`,`up_img`,`display`,`deadline`,`attach`,`view`,`comment`,`extend`,`level`,`list_order`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (24, 0, '这是一个测试', 10, '这是一个测试', '<pre><span style=\"color:#660000;background-color:#f7faff;\">这是一个测试</span></pre>', 1, 0, '0', 'http://thinkphp.con\\uploads\\picture\\2019-04-18\\5cb85df8b2e80.jpg', 1, 0, 0, 0, 0, 0, 0, 50, 1, 1555586776, 1555586776, NULL),(25, 0, '让时间见证我们的辉煌', 10, '2017年8月9日，黑龙江省克山县人民政府与北京怀教网络科技股份有限公司（简称：怀教网络）签订了教育信息化战略合作协议。双方将在教育信息化方面开展多层次、宽领域的战略合作，全面提升克山县教育信息化水平，努力把克山县打造成为教育信息化建设示范县', '<p style=\"font-family:&quot;font-size:16px;color:#3E3E3E;text-indent:43px;background-color:#FFFFFF;\">\n	<span style=\"font-size:14px;\">2017</span><span style=\"font-size:14px;\">年8月9日，黑龙江省克山县人民政府与北京怀教网络科技股份有限公司（简称：怀教网络）签订了教育信息化战略合作协议。双方将在教育信息化方面开展多层次、宽领域的战略合作，全面提升克山县教育信息化水平，努力把克山县打造成为教育信息化建设示范县。</span> \n</p>\n<p style=\"font-family:&quot;font-size:16px;color:#3E3E3E;text-indent:43px;background-color:#FFFFFF;\">\n	<span style=\"font-size:14px;\">克山县政府对此项工作高度重视，专门召开了现场办公会。出席会议的有：克山县县长陈宝柱，副县长刘畅，教育局副局长侯天宇、刘德昌，怀教网络副总经理杜金喆。</span> \n</p>\n<p style=\"font-family:&quot;font-size:16px;color:#3E3E3E;text-indent:43px;background-color:#FFFFFF;\">\n	<span style=\"font-size:14px;\">会上杜金喆详细介绍了公司情况，怀教网络作为一家从事K12教育信息化服务的新三板公司，在教育信息化领域深耕14年，有着深厚的技术底蕴和丰富的实践经验，早在2014年就与克山县教育局建立了良好的合作关系。此次签订的为期十年战略合作协议，公司深感荣幸和责任重大，日后怀教网络将通过共建教育信息化示范校，共搭县域智慧教育云平台，参与编制克山县教育信息化建设规划等，与克山县政府携手打造智慧教育示范县，努力为教育管理者、教师和学生提供精准化和个性化教育服务。</span> \n</p>\n<p style=\"font-family:&quot;font-size:16px;color:#3E3E3E;text-indent:43px;background-color:#FFFFFF;\">\n	<span style=\"font-size:14px;\">刘畅副县长表示，2014年克山县教育城域网的建成，已经让克山县教育信息化工作走在了全市的前列。此次与怀教网络再次合作，特别是搭建县域智慧教育平台，将加快我县完成教育部提出的“三通两平台”任务进程，对于加快我县教育信息化发展必将起到重大的推动作用。</span> \n</p>\n<p style=\"font-family:&quot;font-size:16px;color:#3E3E3E;text-indent:2em;background-color:#FFFFFF;\">\n	<span style=\"font-size:14px;\">陈宝柱县长做了最终总结，他表示此次与怀教网络达成的战略合作内容与克山县教育信息化建设规划方向是一致的，因此对怀教网络助力克山县教育信息化表示欢迎。同时，要求怀教网络在今后的合作中要进一步提升服务质量，提高业务能力，把战略合作内容履行好，共同把克山县打造成为全市、乃至全省的教育信息化建设示范县。</span> \n</p>', 1, 0, '0', 'http://thinkphp.con\\uploads\\picture\\2019-04-18\\5cb850430fd20.jpg', 1, 0, 0, 0, 0, 0, 0, 50, 1, 1555584546, 1555584546, NULL),(26, 0, '关于机房勒索病毒进一步防御的公告', 10, '关于机房勒索病毒进一步防御的公告', '<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">近日，据景安网络“信息安全实验室”调查发现，</span><span style=\"font-family:微软雅黑, &quot;\">勒索病毒的阴霾尚未完全消散</span><span style=\"font-family:微软雅黑, &quot;\">，威胁仍在持续。政府、金融、企业和个人用户均在被攻击目标之列，而最常见的系统漏洞成为勒索软件攻击的主要入口。一旦用户设备感染勒索病毒后，若未提前做好数据备份工作，几乎没有办法来破解，最终极易导致用户设备瘫痪，严重者直接造成无法挽回的经济、名誉等各方面的损失。</span> \n</p>\n<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">为积极响应</span><span style=\"font-family:微软雅黑, &quot;\">上级主管部门的要求</span><span style=\"font-family:微软雅黑, &quot;\">，</span><span style=\"font-family:微软雅黑, &quot;\">全力</span><span style=\"font-family:微软雅黑, &quot;\">防范勒索病毒</span><span style=\"font-family:微软雅黑, &quot;\">的侵害，</span><span style=\"font-family:微软雅黑, &quot;\">进一步推进</span><span style=\"font-family:微软雅黑, &quot;\">《中华人民共和国</span><span style=\"font-family:微软雅黑, &quot;\">网络安全法</span><span style=\"font-family:微软雅黑, &quot;\">》</span><span style=\"font-family:微软雅黑, &quot;\">的实施，</span><span style=\"font-family:微软雅黑, &quot;\">景安网络已</span><span style=\"font-family:微软雅黑, &quot;\">与安全狗</span><span style=\"font-family:微软雅黑, &quot;\">达成</span><span style=\"font-family:微软雅黑, &quot;\">合作，</span><span style=\"font-family:微软雅黑, &quot;\">双方将共同致力于保护用户服务器和网站的安全，景安</span><span style=\"font-family:微软雅黑, &quot;\">用户可通过安装安全狗增加</span><span style=\"font-family:微软雅黑, &quot;\">自身</span><span style=\"font-family:微软雅黑, &quot;\">防护能力</span><span style=\"font-family:微软雅黑, &quot;\">，保障网络与信息安全。除此之外，我公司将进一步把自身产品深入到各服务环节。</span> \n</p>\n<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">另</span><span style=\"font-family:微软雅黑, &quot;\">根据《网络安全法》第二十五条要求：“网络运营者应当制定网络安全事件应急预案，及时处置系统漏洞、计算机病毒、网络攻击、网络侵入等安全风险；在发生危害网络安全的事件时，立即启动应急预案，采取相应的补救措施，并按照规定向有关主管部门报告。”</span><span style=\"font-family:微软雅黑, &quot;\">景安建议各行业用户</span><span style=\"font-family:微软雅黑, &quot;\">务必做到以下几点：</span> \n</p>\n<p style=\"margin-left:28px;font-size:14px;color:#666666;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">1.&nbsp;</span><span style=\"font-family:微软雅黑, &quot;\">建立良好的沟通机制</span> \n</p>\n<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">请您</span><span style=\"font-family:微软雅黑, &quot;\">在我公司业务</span><span style=\"font-family:微软雅黑, &quot;\">后台登记真实有效的信息</span><span style=\"font-family:微软雅黑, &quot;\">（</span><span style=\"font-family:宋体;\"><span style=\"font-family:微软雅黑, &quot;\">若负责人/</span><span style=\"font-family:微软雅黑, &quot;\">联系人信息有变化，请及时与我公司联系</span></span><span style=\"font-family:微软雅黑, &quot;\">进行</span><span style=\"font-family:微软雅黑, &quot;\">更新</span><span style=\"font-family:微软雅黑, &quot;\">）</span><span style=\"font-family:微软雅黑, &quot;\">，确保</span><span style=\"font-family:微软雅黑, &quot;\">我司</span><span style=\"font-family:宋体;\"><span style=\"font-family:微软雅黑, &quot;\">能及时联系到相关负责人/</span><span style=\"font-family:微软雅黑, &quot;\">联系人核实、处理</span></span><span style=\"font-family:微软雅黑, &quot;\">紧急安全事件</span><span style=\"font-family:微软雅黑, &quot;\">。</span><span style=\"font-family:微软雅黑, &quot;\">若</span><span style=\"font-family:微软雅黑, &quot;\">因</span><span style=\"font-family:微软雅黑, &quot;\">信息不正确</span><span style=\"font-family:微软雅黑, &quot;\">导致</span><span style=\"font-family:微软雅黑, &quot;\">我司</span><span style=\"font-family:微软雅黑, &quot;\">无法</span><span style=\"font-family:微软雅黑, &quot;\">与您取得及时</span><span style=\"font-family:微软雅黑, &quot;\">有效</span><span style=\"font-family:微软雅黑, &quot;\">的</span><span style=\"font-family:宋体;\"><span style=\"font-family:微软雅黑, &quot;\">联系，进而采取安全监管措施如网站屏蔽、ip</span><span style=\"font-family:微软雅黑, &quot;\">封停等所引起的一起后果</span></span><span style=\"font-family:微软雅黑, &quot;\">，</span><span style=\"font-family:微软雅黑, &quot;\">由用户自己承担</span><span style=\"font-family:微软雅黑, &quot;\">。</span> \n</p>\n<p style=\"margin-left:28px;font-size:14px;color:#666666;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">2.&nbsp;</span><span style=\"font-family:微软雅黑, &quot;\">建立健全病毒防范措施</span> \n</p>\n<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">请</span><span style=\"font-family:微软雅黑, &quot;\">您</span><span style=\"font-family:微软雅黑, &quot;\">及时联系我司客服、商务人员或自行选择增加网站安全产品，有效防范黑客攻击、数据篡改、病毒、木马软件等</span><span style=\"font-family:微软雅黑, &quot;\">，以便防止</span><span style=\"font-family:微软雅黑, &quot;\">对</span><span style=\"font-family:微软雅黑, &quot;\">自身</span><span style=\"font-family:微软雅黑, &quot;\">网站造成影响</span><span style=\"font-family:微软雅黑, &quot;\">，</span><span style=\"font-family:微软雅黑, &quot;\">确保网站正常运行。</span> \n</p>\n<p style=\"margin-left:28px;font-size:14px;color:#666666;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">3.&nbsp;</span><span style=\"font-family:微软雅黑, &quot;\">容灾备份解决方案</span> \n</p>\n<p style=\"font-size:14px;color:#666666;text-indent:28px;font-family:微软雅黑, &quot;background-color:#FFFFFF;\">\n	<span style=\"font-family:微软雅黑, &quot;\">网站</span><span style=\"font-family:微软雅黑, &quot;\">数据是</span><span style=\"font-family:微软雅黑, &quot;\">各行业的</span><span style=\"font-family:微软雅黑, &quot;\">重要资产，</span><span style=\"font-family:微软雅黑, &quot;\">里面包含了网站自运行以来的所有资料。</span><span style=\"font-family:微软雅黑, &quot;\">必须</span><span style=\"font-family:微软雅黑, &quot;\">做到重要数据随时</span><span style=\"font-family:微软雅黑, &quot;\">备份</span><span style=\"font-family:微软雅黑, &quot;\">，</span><span style=\"font-family:微软雅黑, &quot;\">严忌在</span><span style=\"font-family:宋体;\"><span style=\"font-family:微软雅黑, &quot;\">受到病毒和IT</span><span style=\"font-family:微软雅黑, &quot;\">数据灾难</span></span><span style=\"font-family:微软雅黑, &quot;\">后</span><span style=\"font-family:微软雅黑, &quot;\">才开始重视。</span><span style=\"font-family:微软雅黑, &quot;\">景安网络目前针对用户提供容灾备份解决方案，可</span><span style=\"font-family:微软雅黑, &quot;\">根据</span><span style=\"font-family:微软雅黑, &quot;\">用户行业</span><span style=\"font-family:微软雅黑, &quot;\">场景推</span><span style=\"font-family:微软雅黑, &quot;\">出相应</span><span style=\"font-family:微软雅黑, &quot;\">的</span><span style=\"font-family:微软雅黑, &quot;\">专业</span><span style=\"font-family:微软雅黑, &quot;\">灾备服务，让</span><span style=\"font-family:微软雅黑, &quot;\">用户网络应用</span><span style=\"font-family:微软雅黑, &quot;\">安全无忧。</span> \n</p>', 1, 0, '0', 'http://thinkphp.con\\uploads\\picture\\2019-04-18\\5cb850430fd20.jpg', 1, 0, 0, 0, 0, 0, 0, 50, 1, 1555586533, 1555586533, NULL),(27, 0, '网站对企业的重要性1122aaa', 10, '网站对企业的重要性aaa', '<p style=\"color:#555555;font-family:微软雅黑, &quot;font-size:14px;text-align:justify;background-color:#FFFFFF;\">\n	aaaaccc\n</p>', 1, 0, '11aaabbb', '/storage/uploads/5d9d71cb7cb07.jpg', 1, 0, 0, 0, 0, 0, 0, 50, 1, 1555584553, 1555584553, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_info_article_class` WRITE;
DELETE FROM `lzycms`.`ks_info_article_class`;
INSERT INTO `lzycms`.`ks_info_article_class` (`id`,`name`,`pid`,`sort`,`tip`,`title`,`keywords`,`description`,`logo`,`recommended`,`typeid`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (10, '协议与帮助33', 0, 0, NULL, NULL, '', '', NULL, 0, 2, 1, 1542793452, 1543921488, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_info_bulletin` WRITE;
DELETE FROM `lzycms`.`ks_info_bulletin`;
INSERT INTO `lzycms`.`ks_info_bulletin` (`id`,`title`,`content`,`type`,`lid`,`send_type`,`up_img`,`status_time`,`start_time`,`end_time`,`list_order`,`uid`,`status`,`create_time`,`update_time`,`delete_time`) VALUES (5, '这是另一个测试11', '1232131这是另一个测试这是另一个测试这是另一个测试', 0, 2, 1, 'http://www.xmcrb.com/uploads/2018-11-29-03-20-49-5bff5b11b398e.jpg', 1, '2018-11-02 00:00:00', '2018-11-30 00:00:00', 50, 1, 1, 1542356733, 1543462099, NULL),(8, 'fdsfs', '', 0, 2, 1, '/storage/uploads/5d9d7d0dc4444.jpg', 0, '1570550400', '1572451200', 50, 0, 1, 0, 0, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_info_single` WRITE;
DELETE FROM `lzycms`.`ks_info_single`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_member` WRITE;
DELETE FROM `lzycms`.`ks_member`;
INSERT INTO `lzycms`.`ks_member` (`uid`,`nickname`,`logo`,`sex`,`birthday`,`score`,`login`,`reg_ip`,`last_login_ip`,`last_login_time`,`otp_gg`,`p1`,`p2`,`pids`,`create_time`,`update_time`,`status`) VALUES (1, '超级管理员11121', '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', 1, '2018-10-31', 10, 2, 0, 2130706433, 1524041510, '32131', 0, NULL, NULL, NULL, 1541144879, 1),(7, '超级管理员11aacccdd', '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', 1, '2018-10-31', 0, 0, 0, 0, 0, '', 0, NULL, NULL, 1531816217, 1541051951, 1),(8, '超级管理员11aacccdd', '/uploads/2018-10-31-08-10-48-5bd963882a620.jpg', 1, '2018-10-31', 0, 0, 0, 0, 0, '123131231', 0, NULL, NULL, 1541056004, 1541056036, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_member_level` WRITE;
DELETE FROM `lzycms`.`ks_member_level`;
INSERT INTO `lzycms`.`ks_member_level` (`id`,`level_name`,`vip_pay_times`,`vip_pay_amount`,`pay_max_amount`,`order_money`,`score_all`,`score_consume`,`withdraw_times`,`poundage_amount`,`withdraw_amount`,`status`,`auto`,`memo`,`level_user_num`,`vip_user_num`,`uid`,`create_time`,`update_time`,`delete_time`) VALUES (1, '未分层', 31, 150.000, 0.000, 0.000, 0, 2496, 0, 0.00, 0.000, 1, 1, '2', 691, NULL, 0, NULL, 1546508428, NULL),(2, '开始层', 35, 0.000, 0.000, 0.000, 0, 3578, 0, 0.00, 0.000, 1, 1, '0', 67, NULL, 0, NULL, 1545296686, NULL),(3, '小额层', 5, 1000.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', 1, NULL, 0, NULL, 1541410346, 1541410346),(4, '中额层', 5, 5000.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', 1, NULL, 0, NULL, 1541410342, 1541410342),(5, '大额层', 1, 10000.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '1', 1, NULL, 0, NULL, 1541410337, 1541410337),(6, '充百次', 100, 0.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', NULL, NULL, 0, NULL, 1541410332, 1541410332),(7, '好客层', 1, 0.000, 5000.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', NULL, NULL, 0, NULL, 1541410330, 1541410330),(8, '套利层', 3, 0.000, 0.000, 0.000, 0, 0, 3, 0.00, 0.000, 1, 1, '', NULL, NULL, 0, NULL, 1541410326, 1541410326),(9, '测试层', 0, 0.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', 32, NULL, 0, NULL, 1541410320, 1541410320),(10, '黑名单', 0, 0.000, 0.000, 0.000, 0, 0, 0, 0.00, 0.000, 1, 1, '', 1, NULL, 0, NULL, 1541410315, 1541410315);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_menu` WRITE;
DELETE FROM `lzycms`.`ks_menu`;
INSERT INTO `lzycms`.`ks_menu` (`id`,`title`,`pid`,`sort`,`url`,`icon`,`hide`,`tip`,`group`,`is_dev`,`status`) VALUES (1, '控制台', 0000000000, 100, 'console', 'layui-icon layui-icon-home', 0, NULL, NULL, 0, 0),(2, '系统管理', 0000000000, 50, 'System/*', 'layui-icon layui-icon-set', 0, NULL, NULL, 0, 0),(3, '菜单管理', 0000000002, 50, 'menu/index', 'layui-icon layui-icon-template', 0, NULL, '系统设置', 0, 0),(4, '用户管理', 0000000000, 50, 'user/*', 'layui-icon layui-icon-username', 0, NULL, NULL, 0, 0),(5, '用户信息', 0000000004, 50, 'member/index', 'layui-icon layui-icon-friends', 0, '', '用户管理', 0, 0),(6, '权限管理', 0000000004, 50, 'authmanager/index', 'layui-icon layui-icon-group', 0, NULL, '用户管理', 0, 0),(7, '用户行为', 0000000004, 50, 'action/index', 'layui-icon layui-icon-username', 0, NULL, '行为管理', 0, 0),(8, '配置管理', 0000000002, 50, 'config/group', 'layui-icon layui-icon-refresh-1', 0, NULL, '系统设置', 0, 0),(9, '配置分类', 0000000002, 50, 'config/index', 'layui-icon layui-icon-chat', 0, NULL, '系统设置', 0, 0),(10, '备份数据库', 0000000002, 50, 'database/option/index', 'layui-icon layui-icon-chat', 1, NULL, '数据备份', 1, 0),(11, '用户行为日志', 0000000004, 50, 'actionlog/index', 'layui-icon layui-icon-star', 0, NULL, '行为管理', 0, 0),(12, '商城管理', 0000000000, 50, 'shop/*', 'layui-icon layui-icon-cart-simple', 0, NULL, NULL, 1, 0),(13, '产品列表', 0000000012, 50, 'goods/index', 'layui-icon layui-icon-tree', 0, NULL, NULL, 0, 0),(14, '还原数据库', 0000000002, 50, 'database/option/import', 'layui-icon layui-icon-fonts-strong', 1, NULL, '数据备份', 1, 0),(15, '商品分类', 0000000012, 2, 'shop/goods/class/index', 'layui-icon layui-icon-set-sm', 0, NULL, '0', 0, 0),(18, '内容管理', 0000000000, 50, 'admin/content', 'layui-icon layui-icon-form', 0, NULL, '文章管理', 0, 0),(19, '广告管理', 0000000018, 50, 'adv/index', 'layui-icon layui-icon-carousel', 0, NULL, NULL, 0, 0),(20, '新闻管理', 0000000018, 50, 'article/index', 'layui-icon layui-icon-file', 0, NULL, '新闻管理', 0, 0),(21, '新闻分类', 0000000018, 50, 'articleclass/index', 'layui-icon layui-icon-file', 0, NULL, '新闻管理', 0, 0),(22, '公告管理', 0000000018, 50, 'bulletin/index', 'layui-icon layui-icon-reply-fill', 0, NULL, NULL, 0, 0),(23, '用户层级', 0000000004, 50, 'memberlevel/index', NULL, 0, NULL, '用户管理', 0, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_news` WRITE;
DELETE FROM `lzycms`.`ks_news`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_order_goods` WRITE;
DELETE FROM `lzycms`.`ks_order_goods`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_pay` WRITE;
DELETE FROM `lzycms`.`ks_pay`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_payment` WRITE;
DELETE FROM `lzycms`.`ks_payment`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_picture` WRITE;
DELETE FROM `lzycms`.`ks_picture`;
INSERT INTO `lzycms`.`ks_picture` (`id`,`path`,`url`,`md5`,`sha1`,`status`,`create_time`,`token`) VALUES (14, 'storage/uploads/5d9d71cb7cb07.jpg', '', 'e6bf416bbb100fa261b7e6aaf0528c71', '3677cc72f2e762d4fd7e021aa64cc88cfd082a0b', 0, 0, NULL),(15, 'storage/uploads/5d9d7d0dc4444.jpg', '', '857169135d6d71a81580bcbaeea9b6a6', 'ba4fab641376dad2701fd7b929ae77b8e840dfe5', 0, 0, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_recharge` WRITE;
DELETE FROM `lzycms`.`ks_recharge`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_region` WRITE;
DELETE FROM `lzycms`.`ks_region`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop` WRITE;
DELETE FROM `lzycms`.`ks_shop`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_bank` WRITE;
DELETE FROM `lzycms`.`ks_shop_bank`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_equipment` WRITE;
DELETE FROM `lzycms`.`ks_shop_equipment`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_img` WRITE;
DELETE FROM `lzycms`.`ks_shop_img`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_order` WRITE;
DELETE FROM `lzycms`.`ks_shop_order`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_product` WRITE;
DELETE FROM `lzycms`.`ks_shop_product`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_shop_product_class` WRITE;
DELETE FROM `lzycms`.`ks_shop_product_class`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lzycms`.`ks_ucenter_member` WRITE;
DELETE FROM `lzycms`.`ks_ucenter_member`;
INSERT INTO `lzycms`.`ks_ucenter_member` (`id`,`username`,`password`,`email`,`mobile`,`reg_time`,`reg_ip`,`last_login_time`,`last_login_ip`,`user_type`,`create_time`,`update_time`,`status`) VALUES (1, 'admin', 'd93a5def7511da3d0f2d171d9c344e91', '278805354@qq.com', '13400998033', 1570611728, 0, 1524041510, 2130706433, 1, 1524041496, 1540973722, 1),(7, 'ceshi', '2e4f3322ad83b1f067ab7dc7c178ccef', NULL, '13400998080', 1540968889, 2130706433, 0, 0, 1, 1531816217, 1541051951, 1),(8, 'woha', '2e4f3322ad83b1f067ab7dc7c178ccef', NULL, '13400998011', 1541056004, 2130706433, 0, 0, 1, 1541056004, 1541056035, 0),(16, 'oehJ45H-13WFvCwx_Qe-7zpNDc_8', '123456', NULL, '13400998088', 1541661720, 2015680223, 0, 0, 1, 1541661720, 1541661720, 0);
UNLOCK TABLES;
COMMIT;
